package com.lswms.modules.lswms.excel.stock;

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

import com.baomidou.mybatisplus.annotation.TableField;

/**
 * 属性
 *
 * @author DX sunlightcs@gmail.com
 * @since 1.0.0 2021-06-14
 */
@Data
public class InventoryExcel {
    
    @Excel(name = "物料编码")
    private String sku;
    @Excel(name = "物料名称")
	private String descr;
    @Excel(name = "计量编码/工装号")
	private String factorycdoe;
    @Excel(name = "库位编码")
    private String location;
    @Excel(name = "箱")
    private String tray;
    @Excel(name = "格")
	private String boxstr;
    @Excel(name = "批号")
    private String lot;
    @Excel(name = "数量")
    private BigDecimal qty;
    @Excel(name = "分配量")
    private BigDecimal pickqty;
    @Excel(name = "待上架量")
    private BigDecimal putqty;
    @Excel(name = "生产日期",exportFormat="yyyy-MM-dd")
    private Date lot1;
    @Excel(name = "有效日期",exportFormat="yyyy-MM-dd")
    private Date lot2;
    @Excel(name = "是否加长")
    private String lot3str;
    @Excel(name = "价格")
    private String lot4;
    @Excel(name = "部门/供应商")
    private String lot5;
    @Excel(name = "计划单号/工序号")
    private String lot6;
    @Excel(name = "主制车间")
    private String lot7;
    @Excel(name = "任务编码")
    private String lot8;
    @Excel(name = "新旧")
    private String lot9str;
    @Excel(name = "作废")
    private String lot10str;
    @Excel(name = "炉批号")
    private String lot11;
    @Excel(name = "材料复验号")
    private String lot12;
    @Excel(name = "牌号")
    private String lot13;
    @Excel(name = "属性14")
    private String lot14;
    @Excel(name = "属性15")
    private String lot15;
    @Excel(name = "状态")
    private Integer status;
    @Excel(name = "备注")
    private String remark;
    @Excel(name = "创建人")
    private String adduser;
    @Excel(name = "创建时间",exportFormat="yyyy-MM-dd HH:mm:ss")
    private Date addtime;
    @Excel(name = "更新人")
    private String updatuser;
    @Excel(name = "更新时间",exportFormat="yyyy-MM-dd HH:mm:ss")
    private Date updatetime;
    @Excel(name = "入库订单号")
    private String receiptkey;
    

}